Elements and Performance Criteria
- Select and prepare resources
- Plan spreadsheet design
- Ensure spreadsheet design suits purpose, audience and information requirements of task
- Ensure spreadsheet design enhances readability and appearance, and meets organisational and task requirements for style and layout
- Use available application functions to ensure consistency of design and layout, adhering to organisational and task requirements
- Create spreadsheet
- Enter data, check and amend to maintain consistency of design and layout, in accordance with organisational and task requirements
- Format spreadsheet using application functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
- Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required
- Use relevant help functions to overcome intermediate-level issues with spreadsheet design and production
- Produce intermediate-level charts
- Finalise and present spreadsheets
- Review and edit final spreadsheet and any accompanying charts, and prepare for delivery in accordance with task requirements
- Deliver document to relevant audience within designated timelines and in accordance with organisational requirements for speed and accuracy
- Name and store spreadsheet appropriately in accordance with organisational requirements and exit application without data loss/damage